{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2023-12-03T07:36:18.684175Z",
     "start_time": "2023-12-03T07:36:18.274944600Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "海鸥 ['纯电动销量NO.1'] ['3.3分'] ['共3款符合条件车型'] 7.38-8.98\n",
      "Model Y ['中型SUV销量NO.1'] ['4.04分'] ['共3款符合条件车型'] 26.64-36.39\n",
      "元PLUS ['紧凑型SUV销量NO.1'] ['3.77分'] ['共10款符合条件车型'] 12.78-16.08\n",
      "ZEEKR 001 ['中大型轿车销量NO.6'] ['4.12分'] ['共7款符合条件车型'] 26.90-76.90\n",
      "深蓝S7 ['新增车型'] [] ['共5款符合条件车型'] 14.99-21.79\n",
      "零跑C11 ['中型SUV销量NO.10'] ['3.83分'] ['共4款符合条件车型'] 14.98-20.98\n",
      "深蓝SL03 ['新增车型'] ['3.79分'] ['共6款符合条件车型'] 14.59-67.79\n",
      "Model 3 [] ['4.02分'] ['共2款符合条件车型'] 26.14-29.74\n",
      "五菱缤果 ['小型轿车销量NO.3'] ['3.37分'] ['共6款符合条件车型'] 5.68-8.48\n",
      "AION Y ['新增车型'] ['3.71分'] ['共9款符合条件车型'] 10.98-14.38\n",
      "五菱宏光MINIEV ['2024新款'] ['2.77分'] ['共25款符合条件车型'] 2.98-9.99\n",
      "哪吒S ['2024新款'] ['4.04分'] ['共13款符合条件车型'] 15.18-32.68\n",
      "海豚 ['小型轿车销量NO.2'] ['3.47分'] ['共5款符合条件车型'] 11.68-13.98\n",
      "宝马i3 ['2023新款'] ['3.96分'] ['共6款符合条件车型'] 21.39-26.90\n",
      "大众ID.3 ['纯电动销量NO.11'] ['3.84分'] ['共2款符合条件车型'] 12.59-14.99\n",
      "智界S7 ['全新车系'] [] ['共4款符合条件车型'] 24.98-34.98\n",
      "汉EV ['中大型轿车销量NO.5'] ['4.02分'] ['共5款符合条件车型'] 19.98-27.98\n",
      "问界M5 [] ['3.93分'] ['共5款符合条件车型'] 24.98-33.18\n",
      "海豹 [] ['3.95分'] ['共5款符合条件车型'] 18.98-27.98\n",
      "小鹏P7 ['新增车型'] ['3.94分'] ['共11款符合条件车型'] 20.49-32.49\n",
      "零跑C01 ['中大型轿车销量NO.8'] ['3.95分'] ['共5款符合条件车型'] 14.58-20.88\n",
      "秦PLUS EV ['新增车型'] ['3.61分'] ['共14款符合条件车型'] 11.98-17.58\n",
      "长安Lumin ['微型轿车销量NO.2'] ['3.3分'] ['共5款符合条件车型'] 3.99-6.19\n",
      "AION S ['纯电动销量NO.12'] ['3.67分'] ['共16款符合条件车型'] 11.98-19.79\n",
      "宋PLUS EV ['纯电动销量NO.13'] ['3.81分'] ['共6款符合条件车型'] 16.48-20.48\n",
      "MG Cyberster ['全新车系'] [] ['共3款符合条件车型'] 31.98-35.98\n",
      "小鹏G9 ['中大型SUV销量NO.6'] ['4.06分'] ['共12款符合条件车型'] 26.39-41.99\n",
      "别克E5 ['中大型SUV销量NO.17'] ['4.03分'] ['共6款符合条件车型'] 16.99-27.89\n",
      "ID.4 CROZZ [] ['3.98分'] ['共10款符合条件车型'] 14.79-22.89\n",
      "长安启源A07 ['中大型轿车销量NO.9'] ['4分'] ['共2款符合条件车型'] 14.79-16.89\n"
     ]
    }
   ],
   "source": [
    "import json\n",
    "\n",
    "import requests\n",
    "from lxml import etree\n",
    "from fontTools.ttLib import TTFont\n",
    "import re\n",
    "\n",
    "headers = {\n",
    "    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69'\n",
    "}\n",
    "url = 'https://www.dongchedi.com/auto/library/x-x-x-x-x-x-4-x-x-x-x'\n",
    "num_code = {\n",
    "    r'\\u' + hex(58400)[2:]: '0',\n",
    "    r'\\u' + hex(58381)[2:]: '1',\n",
    "    r'\\u' + hex(58403)[2:]: '2',\n",
    "    r'\\u' + hex(58377)[2:]: '3',\n",
    "    r'\\u' + hex(58397)[2:]: '4',\n",
    "    r'\\u' + hex(58407)[2:]: '5',\n",
    "    r'\\u' + hex(58393)[2:]: '6',\n",
    "    r'\\u' + hex(58365)[2:]: '7',\n",
    "    r'\\u' + hex(58408)[2:]: '8',\n",
    "    r'\\u' + hex(58387)[2:]: '9'\n",
    "}\n",
    "response = requests.get(url, headers=headers)\n",
    "html = response.text\n",
    "html_doc = etree.HTML(html)\n",
    "div = html_doc.xpath('/html/body/div[1]/div[1]/div[2]/div/ul//li[@class=\"car-list_item__3nyEK\"]/div')\n",
    "for info in div:\n",
    "    name = info.xpath('./a[@class=\"series-card_name__3QIlf\"]/text()')[0]\n",
    "    tag = info.xpath('./span[@class=\"series-card_tag__SzPwp\"]/text()')\n",
    "    score = info.xpath('./a[@class=\"series-card_score__2w2hO\"]/text()')\n",
    "    car_type = info.xpath('./div[@class=\"tw-relative car-selector_root__3b8GR series-card_count__3MQyn\"]/text()')\n",
    "    price = info.xpath('./p[@class=\"series-card_price__1Pwwb\"]/text()')[0][:-1].encode('unicode_escape').decode('utf-8')\n",
    "    for i in num_code:\n",
    "        price = price.replace(i, num_code[i])\n",
    "    print(name, tag, score, car_type, price)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "比亚迪 海鸥 [74488, 81386, 81387] 3.3 7.38-8.98万\n",
      "特斯拉 Model Y [94306, 94304, 94305] 4.04 26.64-36.39万\n",
      "比亚迪 元PLUS [71880, 93468, 93467, 55645, 93465, 93466, 93464, 59711, 55068, 59708] 3.77 12.78-16.08万\n",
      "极氪 ZEEKR 001 [95199, 81131, 81130, 81129, 81132, 81128, 92348] 4.12 26.90-76.90万\n",
      "深蓝汽车 深蓝S7 [94952, 90897, 95575, 90896, 95504] 0 14.89-21.69万\n",
      "零跑汽车 零跑C11 [86835, 86836, 86820, 86837] 3.83 14.48-20.48万\n",
      "深蓝汽车 深蓝SL03 [92782, 76430, 94957, 76431, 92781, 95147] 3.79 14.49-67.79万\n",
      "特斯拉 Model 3 [81276, 93070] 4.02 26.14-29.74万\n",
      "五菱汽车 五菱缤果 [87035, 87033, 93905, 87036, 87034, 86906] 3.37 5.98-8.88万\n",
      "埃安 AION Y [88055, 86977, 88056, 91414, 88052, 88053, 95303, 92672, 88054] 3.71 11.98-15.38万\n",
      "五菱汽车 五菱宏光MINIEV [79930, 72480, 77162, 72466, 72468, 72467, 72308, 76902, 72481, 59192, 72479, 72475, 72478, 79931, 77161, 72934, 72935, 72477, 72474, 72476, 79932, 96348, 76901, 79759, 79929] 2.77 2.98-9.59万\n",
      "哪吒汽车 哪吒S [76588, 76568, 91643, 76040, 96467, 74870, 91645, 76565, 96465, 91644, 88500, 96466, 96468] 4.04 15.98-34.18万\n",
      "比亚迪 海豚 [93940, 81035, 93941, 81037, 81036] 3.47 11.68-13.98万\n",
      "宝马 宝马i3 [85889, 85904, 94933, 50542, 95844, 94934] 3.96 24.49-30.19万\n",
      "大众 大众ID.3 [88860, 88862] 3.84 12.59-14.99万\n",
      "智界 智界S7 [95768, 95767, 95766, 95765] 0 24.98-34.98万\n",
      "比亚迪 汉EV [85842, 85839, 85837, 85843, 85838] 4.02 19.98-27.98万\n",
      "AITO 问界M5 [88698, 75090, 88699, 75025, 88713] 3.93 24.98-33.18万\n",
      "比亚迪 海豹 [89472, 89537, 89475, 89474, 89473] 3.95 18.28-27.28万\n",
      "小鹏汽车 小鹏P7 [95463, 74017, 80147, 74018, 80146, 75845, 95539, 87109, 85797, 91378, 74026] 3.94 20.99-32.49万\n",
      "零跑汽车 零跑C01 [86832, 86834, 86833, 86830, 86831] 3.95 14.08-20.38万\n",
      "比亚迪 秦PLUS EV [88327, 88329, 54798, 88330, 88332, 52911, 88331, 95739, 87671, 54799, 89501, 51513, 52909, 52910] 3.61 11.98-17.88万\n",
      "长安 长安Lumin [73701, 72631, 92264, 73427, 94806] 3.3 3.99-6.19万\n",
      "埃安 AION S [93427, 95134, 95136, 95135, 92673, 88049, 95132, 88051, 88045, 93426, 88050, 93428, 88047, 95131, 85817, 88048] 3.67 13.98-20.29万\n",
      "比亚迪 宋PLUS EV [90457, 52740, 90458, 52880, 88510, 88503] 3.81 16.48-20.48万\n",
      "名爵 MG Cyberster [91717, 88461, 91718] 0 31.98-35.98万\n",
      "小鹏汽车 小鹏G9 [78496, 93909, 78499, 78497, 78573, 93908, 78574, 93907, 93906, 78498, 93911, 78495] 4.06 26.39-41.99万\n",
      "别克 别克E5 [94874, 88526, 88524, 88525, 88529, 88527] 4.03 16.98-27.88万\n",
      "大众 ID.4 CROZZ [93522, 73271, 74531, 73267, 93524, 73274, 93523, 94659, 73277, 73270] 3.98 14.79-23.24万\n",
      "长安启源 长安启源A07 [93633, 93634] 4 14.79-16.89万\n"
     ]
    }
   ],
   "source": [
    "import json\n",
    "form = {\n",
    "    'fuel_form': 4,\n",
    "    'sort_new': 'hot_desc',\n",
    "    'city_name': '广州',\n",
    "    'limit': 30,\n",
    "    'page': 1\n",
    "}\n",
    "resp = requests.post('https://www.dongchedi.com/motor/pc/car/brand/select_series_v2?aid=1839&app_name=auto_web_pc',headers=headers,data=form)\n",
    "json_data = json.loads(resp.text)\n",
    "data = json_data.get('data',{}).get('series',[])\n",
    "for i in data:\n",
    "    brand_name = i.get('brand_name','')\n",
    "    outter_name = i.get('outter_name','')\n",
    "    car_ids = i.get('car_ids',[])\n",
    "    dcar_score = i.get('dcar_score','')\n",
    "    dealer_price = i.get('dealer_price','').encode('unicode_escape').decode('utf-8')\n",
    "    for j in num_code:\n",
    "        dealer_price = dealer_price.replace(j, num_code[j])\n",
    "    dealer_price = dealer_price.encode('utf-8').decode('unicode_escape')\n",
    "    print(brand_name,outter_name,car_ids,dcar_score,dealer_price)"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2023-12-03T08:10:13.766215400Z",
     "start_time": "2023-12-03T08:10:13.473017200Z"
    }
   },
   "id": "c6280f49d886e774"
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "outputs": [
    {
     "data": {
      "text/plain": "[['活力版', 2023, '7.38万', '7.38万'],\n ['自由版', 2023, '7.88万', '7.88万'],\n ['飞翔版', 2023, '8.98万', '8.98万']]"
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = 'https://www.dongchedi.com/motor/pc/car/series/car_dealer_price'\n",
    "params = {\n",
    "    'aid': '1839',\n",
    "    'app_name': 'auto_web_pc',\n",
    "    'car_ids': '81387,81386,74488',\n",
    "    'city_name': '广州'\n",
    "}\n",
    "resp_car = requests.get(url,headers=headers,params=params)\n",
    "json_data = json.loads(resp_car.text)\n",
    "data = json_data.get('data',{})\n",
    "car_info_list = []\n",
    "for car_id in data:\n",
    "    car_name = data[car_id].get('car_name','')\n",
    "    year = data[car_id].get('year','')\n",
    "    official_price = data[car_id].get('official_price','')\n",
    "    dealer_price = data[car_id].get('dealer_price','')\n",
    "    car_info_list.append([car_name,year,official_price,dealer_price])\n",
    "car_info_list"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2023-12-03T09:27:46.532511100Z",
     "start_time": "2023-12-03T09:27:46.295033100Z"
    }
   },
   "id": "276f65b774135fa8"
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "81387, 81386, 74488\n",
      "94304, 94305, 94306\n",
      "59711, 55645, 71880, 59708, 93464, 55068, 93465, 93467, 93466, 93468\n",
      "81132, 81128, 95199, 81130, 92348, 81131, 81129\n",
      "95575, 90897, 94952, 95504, 90896\n",
      "86835, 86820, 86836, 86837\n",
      "92781, 95147, 76431, 76430, 92782, 94957\n",
      "93070, 81276\n",
      "87035, 87036, 87033, 93905, 86906, 87034\n",
      "92672, 88053, 88055, 88056, 88052, 91414, 88054, 86977, 95303\n",
      "72481, 72476, 72480, 72475, 79929, 76902, 72467, 72308, 79932, 79931, 79930, 59192, 77161, 96348, 72468, 72935, 72479, 79759, 76901, 72478, 77162, 72474, 72477, 72466, 72934\n",
      "91645, 76565, 91643, 76588, 96465, 96468, 74870, 76568, 76040, 96467, 88500, 91644, 96466\n",
      "81037, 81036, 93941, 93940, 81035\n",
      "85889, 85904, 94933, 94934, 95844, 50542\n",
      "88862, 88860\n",
      "95766, 95765, 95767, 95768\n",
      "85843, 85837, 85839, 85838, 85842\n",
      "88698, 75025, 88713, 75090, 88699\n",
      "89472, 89474, 89475, 89473, 89537\n",
      "95463, 74017, 80147, 87109, 95539, 80146, 85797, 91378, 75845, 74026, 74018\n",
      "86834, 86833, 86831, 86832, 86830\n",
      "88330, 52911, 51513, 52909, 95739, 52910, 88332, 88331, 54799, 87671, 88329, 89501, 54798, 88327\n",
      "94806, 92264, 73701, 72631, 73427\n",
      "93427, 95135, 95132, 93428, 95136, 93426, 88050, 88045, 85817, 88048, 95131, 88049, 95134, 92673, 88051, 88047\n",
      "52740, 90458, 88503, 52880, 88510, 90457\n",
      "88461, 91718, 91717\n",
      "78498, 93911, 93907, 93909, 93908, 78573, 93906, 78574, 78495, 78499, 78497, 78496\n",
      "88529, 94874, 88524, 88525, 88526, 88527\n",
      "73271, 73274, 93523, 93524, 73270, 94659, 93522, 74531, 73267, 73277\n",
      "93634, 93633\n",
      "86828, 86821, 86827, 86829\n",
      "95625, 95996, 94624\n",
      "92817, 92820, 92821, 92819, 87003, 92818\n",
      "90220, 72500, 76779, 90219, 72501\n",
      "91499, 90517, 93650, 92450, 91512, 90622\n",
      "80144, 92710, 88945, 88631, 81169, 85958, 81025, 92602, 78040\n",
      "87857, 96083, 87858, 87860, 78048, 96085, 96046, 96087, 96086\n",
      "95541, 92119, 92117, 92118\n",
      "91495, 92786, 86344\n",
      "94675, 94676\n",
      "86421, 92596, 86785, 92651, 86420\n",
      "78347, 81555, 78348, 81556\n",
      "59678, 59679, 57355\n",
      "88569, 88571, 88570, 88572\n",
      "90729, 91043, 87048, 91042, 87043\n",
      "89482, 89642\n",
      "94820, 94819, 94030, 88844, 88845, 88846, 88843\n",
      "73825, 73823, 52103, 58476, 73824, 73822, 52102, 52104, 52105\n",
      "88865, 88867, 91572, 88866, 88864\n",
      "91617, 91615, 91613, 91614, 91616\n",
      "74280, 56550, 95995, 74279\n",
      "79706, 79705\n",
      "81040, 81240\n",
      "79962, 79963, 77299, 77297, 87116, 93419, 77298\n",
      "75170, 75785, 75784, 75024\n",
      "88044, 88062, 88065, 88043, 88058, 88064, 88059, 88042, 88060, 88063, 88061, 88041\n",
      "80979, 80981, 80980, 80978, 80982\n",
      "95144, 95145, 95146\n",
      "92741, 91157, 74412, 92734, 88370, 57412, 92742, 92412, 92288, 92287, 93841, 73287, 74414, 57413, 92743, 74415\n",
      "87148, 94227, 86236, 94224, 81488, 94223, 87147, 94225, 94226, 86235\n",
      "86071, 90524, 86076, 86073, 86070, 86075, 86072\n",
      "90781, 90778, 77347, 90682, 90769, 90780, 90779, 77345, 90768, 95681\n",
      "81242, 81041\n",
      "92656, 92658, 92657, 59193, 55643, 55644\n",
      "94101, 93191\n",
      "95920, 78784, 95922\n",
      "77371, 77372, 93902, 91590\n",
      "95066, 94731, 86050, 95190, 86051, 95191, 86043, 86047, 86045, 87879, 86049, 86046, 86053, 86052, 86044\n",
      "95104, 93627, 93628, 93629, 92243, 92241, 95103, 92242\n",
      "91132, 73514, 85803, 78883, 91133, 85801, 77612, 73239, 73515, 85808, 73238, 91134, 85802, 91135, 85807, 91131\n",
      "74995, 74994, 74990, 74992, 74993, 74988, 74989, 74991\n",
      "88308, 88307, 88312\n",
      "94085, 86912, 73771, 74914, 94084, 92891, 73770, 94586, 80062\n",
      "79237, 80479, 91487, 79701, 91486, 73559, 73094\n",
      "79557, 77441, 77440\n",
      "89736, 89737\n",
      "92706, 92708, 92707, 94014, 92709, 94013\n",
      "54256, 54255, 86419\n",
      "91501, 73244, 85810, 73246, 85809, 73245, 73247\n",
      "80845, 90638\n",
      "93525, 73262, 74828, 73259, 73260, 93528, 93526, 73261, 93527\n",
      "72756, 79503, 78690, 72755\n",
      "91900, 91899, 91898, 91901, 91897, 96069, 94188\n",
      "90625, 90636, 51138, 92320, 90633, 77021, 90635, 53280, 90634, 89871, 77040, 51137, 77022, 76086, 77047\n",
      "88817, 88813, 88816\n",
      "90189, 90190, 79116, 90188\n",
      "55709, 54007, 75212\n",
      "95974, 86549\n",
      "81336, 81338, 81334\n",
      "88690, 88686, 93071, 93072, 88687, 80668, 94824, 88688, 88689, 93074, 93073\n",
      "86176, 86177, 91694, 86175, 91693\n",
      "74549, 74550, 74551\n",
      "86125, 86124\n",
      "91396, 91398, 91537, 91397\n",
      "86390, 86391, 87729, 86392\n",
      "88208, 88209, 89498\n",
      "93437, 94770, 94771, 94772, 94773\n",
      "91786, 92127, 92128, 92126\n",
      "88868, 88870, 88869, 88871\n",
      "93550, 91584, 93549, 92592\n",
      "74779, 71921\n",
      "92815, 92813, 92812, 92814\n",
      "74768, 88368, 80291, 80290, 81052, 81139, 74767\n",
      "78703, 80406, 74464\n",
      "80730, 80729\n",
      "72820\n",
      "90452, 90738, 90445, 90739, 90453\n",
      "74297, 77270, 74298\n",
      "90048\n",
      "95483, 95484, 95482\n",
      "88725, 88726, 88727\n",
      "92843, 92893, 92828, 92829\n",
      "91207, 91202, 91204, 91203, 91206, 91205\n",
      "93928, 87720\n",
      "91586, 52681, 91587, 72334, 91585, 52682, 72050, 52683\n",
      "96038, 92452, 92857\n",
      "74053, 74048, 74055, 74050, 74049, 74052, 93543, 74051, 74056\n",
      "79539, 92454, 73393, 73392, 73390, 73389, 73998, 73391, 77072\n",
      "89981, 89980, 89978, 93870, 87062, 89982, 89979\n",
      "93929, 93930\n",
      "56239, 56204, 57082, 59715\n",
      "48207, 90650, 47843, 43295, 92322, 90652, 77005, 90653, 77050, 90648, 77006\n",
      "80249\n",
      "90313, 88363, 90314, 90312\n",
      "77749, 81478, 81479, 80558, 87195, 77750, 80559\n",
      "94822, 94823, 81308, 81310, 81309\n",
      "53039, 53037, 53038\n",
      "73896, 73893, 73898, 73892, 73292\n",
      "77575, 77573, 55246, 77572, 77576, 77577, 72698, 77574\n",
      "94868, 94866, 95903, 94869, 94867, 95904\n",
      "72746, 57077, 72747, 57092\n",
      "92718, 92720, 92717, 92721, 92719\n",
      "91517, 90654, 94979\n",
      "91057, 91054, 91058\n",
      "92597, 88872\n",
      "73395, 73396, 77073, 73394, 73398, 73397, 73999\n",
      "75255, 75207, 75276, 75208, 75275\n",
      "73901, 73905, 73904, 73903, 73902\n",
      "91488, 94157, 86782, 93639, 91790, 94156, 86781\n",
      "95881, 96033, 96034, 96035\n",
      "94045, 94044, 94047, 94046\n",
      "78178, 78219, 94463\n",
      "80272, 80271, 80273, 80270\n",
      "92842\n",
      "59199, 74763, 74696, 74764\n",
      "95054, 80243, 87674, 80245, 80244, 95052, 80285, 95760, 87673\n",
      "96049, 92853, 96051, 92854, 96050, 92856, 95951\n",
      "95999, 96001, 96000, 95998\n",
      "79100, 56702, 56701, 71539, 57973, 57972\n",
      "92788\n",
      "80881, 80977, 81008, 80882, 80880\n",
      "58457\n",
      "78212, 77421, 78213, 77420\n",
      "94878, 93733, 93732, 93731, 94879, 94880\n",
      "91237\n",
      "59838\n",
      "72219, 86006, 85996, 86369, 86000, 72218, 86005, 85999, 86366, 86136, 86153, 86368, 86154, 86003, 72224, 86139, 86140, 86155, 72226, 86135, 85997, 86002, 86152, 72225, 93990, 86354, 72217\n",
      "56692, 56694, 56693\n",
      "71624, 80841, 79985, 73665\n",
      "79924, 74344, 74341, 79922, 74343, 74342, 79923, 79925\n",
      "56820\n",
      "79832, 90533\n",
      "90258, 79928, 90255, 75649, 90257, 90256, 90253, 90254, 75650, 75648, 87881\n",
      "95860, 79578, 79579, 79580\n",
      "55708\n",
      "94877, 74861, 74860, 94876, 74859, 94875\n",
      "60186, 81284, 75429, 60189\n",
      "86886\n",
      "79664, 88407, 87196, 86027\n",
      "87744, 87745, 87753, 87751, 88089, 79479, 87746, 79480, 79473, 87752, 79472\n",
      "79197, 79190, 76625, 79191, 59051, 79196, 79195, 79189, 79193, 59056, 79188, 59050, 79194, 79192, 71644, 59049, 76624\n",
      "86919, 86920, 88601\n",
      "58959, 34077, 40054, 45952, 40058, 40055, 47528, 78315, 47529, 74235, 74234, 46928\n",
      "73373, 73369, 73371, 90437, 90435, 90439, 90436, 73367, 73374, 90440, 73372, 73370, 90434\n",
      "93597, 93595, 93594, 93598, 93596\n",
      "73964, 73963, 77145, 71660, 77146\n",
      "35583, 30828\n",
      "76497\n",
      "38754\n",
      "92133, 79837, 73567, 92134\n",
      "90540, 92844, 87163, 92922\n",
      "93590, 93588, 93589, 93593\n",
      "59252, 59253\n",
      "91126, 78441, 91123, 78442, 91127, 91125, 91130, 91124, 78332, 91128, 78333, 78439, 78334\n",
      "71884, 87442\n",
      "75869, 75871, 60174, 75870, 74443, 93192, 60188, 74444, 60176, 60175\n",
      "80299, 96288, 80758, 79849, 80757\n",
      "47438, 47439\n",
      "87377, 87373, 87374, 87375\n",
      "88863\n",
      "77127, 50908, 50665, 77140\n",
      "85811, 78414, 75332, 75333, 75334, 78413, 80053\n",
      "92628, 87951, 92629, 87950, 92627\n",
      "90844, 90378, 90373, 90845, 90379, 90376, 90375, 90377, 90374\n",
      "81491\n",
      "35158, 35159\n",
      "52377, 52197, 52093\n",
      "96407, 89520\n",
      "71754\n",
      "76866, 52189, 77054, 54178, 76865, 77052\n",
      "58524\n",
      "91347, 73196, 91474, 89058, 88920, 92958, 91475, 96297, 90477, 88589, 89593, 93014, 79692, 79693, 88919, 95126, 90476, 79690, 73195, 79689, 79695, 96094, 88921\n",
      "73768, 73146, 73767, 94411, 73144, 60277, 95026\n",
      "88533, 94710, 94711\n",
      "53560, 72932\n",
      "51992, 51991, 51990\n",
      "75741, 75739, 55675, 75742, 55676, 75743, 75740\n",
      "96258, 88130, 86067, 96257, 75204, 88388, 96260, 75203, 75199, 80236, 75198, 75200, 75202, 96259, 75201, 88387\n",
      "87345, 74839, 90412, 90407, 87348, 90414, 90415, 74855, 74840, 90876, 87344, 90878, 74851, 90416, 90890, 74853, 90410, 87336, 96311, 87333, 90877, 74841, 87342, 90889, 90887, 87339, 87338, 74843, 87347, 87334, 90411, 74852, 74842, 96404, 96312, 74854, 87343, 74844, 90408, 87337, 74850, 90875, 90888, 87341, 90409, 90413, 87346, 87340, 87335\n",
      "79942, 79940, 94018, 79941, 89099\n",
      "90656, 90655\n",
      "56491, 54055, 53713\n",
      "86353, 92101, 92103, 86351, 86355, 92104, 86360, 86350, 86356, 86358, 92109, 92112, 92108, 86352, 92102, 92100, 86359, 92110, 86357, 92111, 92099\n",
      "93678, 90489, 94466\n",
      "72750\n",
      "73110, 73138, 77056, 73109, 87157, 87161, 87159, 73137, 87160, 77057\n",
      "73205\n",
      "87262, 71805, 71801, 87266, 71803, 71804, 71800, 71802, 87265, 71795, 87261, 71799, 71794\n",
      "78493, 73028\n",
      "77111, 73163, 73162, 73159, 73157, 73161\n",
      "92516, 92517\n",
      "74944, 95014, 95013, 81148, 74943\n",
      "55722, 55723, 55721, 76486, 55725, 55726, 94424, 55728, 93163, 55724, 55730, 55720, 55729, 55727, 76488, 93164, 55719\n",
      "89650, 85820, 85989, 92665, 85818, 85814, 85819, 89654, 89655, 85816, 89652, 89651, 85815, 89653, 87954, 85821\n",
      "80365, 80364\n",
      "34950, 35068\n",
      "52179, 52178\n",
      "92575, 95755, 92574, 95749, 88038, 54150, 53333, 88039, 53079, 92573, 92159, 54149\n",
      "87539, 73668, 81467, 73671\n",
      "77654, 77653, 77657, 77658, 77656, 77655, 77659\n",
      "92642, 92641, 92639, 92640, 92643\n",
      "90036\n",
      "81029, 80337, 92409, 81460, 92410, 81028, 81459\n",
      "89358, 94252, 79794, 94251, 89354, 93668, 89355, 89356, 89357, 79419, 79795, 94248, 93669, 94247, 94249, 94250\n",
      "78418, 78426, 73068, 73057, 78421, 92458, 73049, 95751, 92456, 78417, 78416, 73067, 73072, 73066, 78425, 73050, 92460, 73055, 78424, 92461, 78415, 78419, 95750, 78422, 78423, 95752, 92459, 95754, 95753, 95756, 92457, 78420\n",
      "85926, 90246, 90247, 85927, 90248, 85928\n",
      "53594, 75699, 80989\n",
      "35425, 35426\n",
      "88293, 92722, 92725, 93600, 88292, 93601\n",
      "86323, 91323, 91319, 91325, 86317, 86325, 91317, 91322, 86322, 91318, 86320, 86319, 92069, 92070, 72742, 92131, 80261, 96307, 86318, 92063, 92071, 92066, 88404, 72741, 92064, 91320, 92130, 86321, 96306, 92067, 92068, 91321, 91326, 91324, 86324, 92065\n",
      "53824, 53827, 53831, 53828, 53821, 53818, 53832, 53837, 53822, 53830, 76484, 53833, 53825, 53829, 53835, 76485, 53834, 53826, 53836, 53823, 53819\n",
      "53754\n",
      "79060, 79059\n",
      "48998, 49003, 49002, 48997\n",
      "80362, 80363\n",
      "90223, 91433, 90221, 91432\n",
      "40048, 40049\n",
      "56305, 71987, 71986, 71985, 59888, 71983, 71984\n",
      "79028, 79029\n",
      "75388, 92668, 75386, 81339\n",
      "79508\n",
      "42049, 45305, 45306, 45303, 45307\n",
      "93617, 93620, 93619, 93624, 93621, 93622, 93623, 93626\n",
      "93892, 90492, 93893, 93891\n",
      "89496\n",
      "29579\n",
      "92138, 92141, 72740, 60091, 86312, 86311, 86309, 86308, 92137, 92143, 60089, 86314, 86313, 92132, 92140, 92135, 88405, 60088, 60090, 92142, 86315, 92139, 92136, 86316\n",
      "58985, 58986, 58984\n",
      "80133, 80132, 57293, 80130, 80127, 80134\n",
      "96346, 96342, 96344, 96343, 96345\n",
      "91342, 80183, 91339, 85951, 85952, 91341, 91340\n",
      "73213, 73212\n",
      "76903, 86280, 86278, 86282\n",
      "86032, 86035, 86036, 86034, 86033, 86031\n",
      "55229, 55232, 60087, 88403, 55228, 55230, 55231\n",
      "74960, 74957, 74961, 90208, 74967, 74954, 74963, 90209, 74966, 74959, 74965, 74964, 74962, 74956, 74958\n",
      "80993, 36646, 36647, 80100, 91264, 80099, 80999, 91263, 79003, 79004, 80098, 81000\n",
      "95666, 95669, 95656, 95665, 95658, 95653, 95668, 95667, 95654, 94401, 95664, 95662, 95657, 95660, 95655, 95659, 95663\n",
      "74338, 74340, 74619, 81233, 74339, 86418, 74620, 81231\n",
      "89081\n",
      "90399, 90398, 71796, 71798, 90401, 90397, 90400\n",
      "93520\n",
      "94525, 76825, 94530, 94523, 88390, 94524, 94529, 95810, 94528, 78998, 78997, 91327, 94526\n",
      "74915, 74918, 81296, 81294, 74917, 81297, 81298, 81292, 81293, 74916, 81295\n",
      "29384\n",
      "72816\n",
      "93608, 93610, 93613, 76926, 76927, 93036, 76786, 93612, 93614, 76925\n",
      "76968, 79038, 79039\n",
      "72999, 73000, 73004, 73003\n",
      "95840, 95854\n",
      "81299\n",
      "81005, 59959, 80996, 59961, 71286, 81003, 81001, 71284, 59958, 59960, 59957, 59962, 80997, 80998, 80994, 75023, 71281, 81002, 81004, 80995\n",
      "74776, 74774, 92487, 74777, 92488\n",
      "43313, 52126, 48084, 52125\n",
      "87030, 87031, 87027, 87029\n",
      "86769\n",
      "51626\n",
      "94182, 94183, 94002, 94003\n",
      "90774, 90773, 93715, 93716, 90775\n",
      "41037, 41038\n",
      "52708, 52707\n",
      "92748, 92747\n",
      "92495, 92494, 92496, 56764, 92497, 56763, 56765\n",
      "75551, 75550\n",
      "93602, 88289, 92726, 88290, 88990, 92728\n",
      "91443\n",
      "44202, 36212, 46896, 36215, 35913, 36213, 36211, 39651\n",
      "86853, 86854, 86852\n",
      "78637, 78639, 78638\n",
      "72715\n",
      "93992\n",
      "92795, 79920, 78668, 92794\n",
      "89341, 75218, 89344, 89336, 75219, 89335, 75217, 89342, 75216, 89337, 89338, 89339, 89343, 89340\n",
      "75597, 81141, 53159, 75991, 55889\n",
      "86014, 80637, 81190, 88111\n",
      "72266, 57196, 72265\n",
      "46925, 47139, 47140\n",
      "91240, 94051, 94050\n",
      "87320, 87319\n",
      "29702\n",
      "31879, 31880\n",
      "77986, 77984, 77981\n",
      "89137, 89136, 89132, 89130, 89139, 89131, 89134, 89140, 89135, 89133, 89138\n",
      "73293, 72781, 71649, 72957\n",
      "76894\n",
      "86285, 86287, 86293, 86273\n",
      "92511, 92502, 92499, 92503, 92514, 92512, 92510, 92498, 92504, 92509, 92515, 92513, 92505, 92500, 92501, 92508\n",
      "86795, 86798, 86803, 86796, 73278, 86799, 86797, 73279, 86801\n",
      "28974\n",
      "76749, 77511, 77510, 76750\n",
      "95183, 95181, 95179, 95180, 95182\n",
      "88708\n",
      "32080, 53689, 32078, 6757, 32079\n",
      "89615, 88489\n",
      "72240\n",
      "29798\n",
      "32823\n",
      "87633, 76612, 76613, 87351, 76614, 87350, 87354, 87632, 87353, 72140, 87629, 56813, 87349, 76615, 87352\n",
      "55236, 55237, 55235, 55234, 55238, 88406, 55233\n",
      "87362, 75404, 87361, 75405, 91002, 91003\n",
      "78377, 78378\n",
      "52702, 72967\n",
      "87618, 72206, 72204, 72205, 72203\n",
      "29779\n",
      "77822, 77821, 77820, 73350, 88243\n",
      "29133\n",
      "94870\n",
      "77244\n",
      "54852, 91884, 54851, 54847, 91880, 54848, 91885, 91877, 85875, 54850, 91882, 91883, 91886, 54849, 91888, 85874\n",
      "95022, 95009, 95016, 94986, 94990, 95000, 94913, 94910, 95017, 95018, 94908, 95003, 94987, 94992, 95002, 94914, 95010, 94993, 94997, 95011, 94991, 95019, 95012, 94911, 95023, 95005, 95004, 95001, 94909, 95021, 94996, 95020\n",
      "52309, 49528\n",
      "72397\n",
      "25448\n",
      "30823\n",
      "71349\n",
      "25034\n",
      "22928\n",
      "29343\n",
      "34889, 34105, 34890, 34891\n",
      "75672\n",
      "29413\n",
      "29462\n",
      "72442, 72441, 94713, 80404, 60257\n",
      "73382, 85876, 85877\n",
      "75857, 75858\n",
      "87893, 87891, 87892, 87894, 87890, 87889, 79819, 54716, 87895\n",
      "73378\n",
      "86615, 86305, 86304, 86614\n",
      "56206, 56205, 56207\n",
      "75064, 75057, 75060, 75063, 75067, 75066, 75068, 78974, 93145, 78975, 93142, 75055, 75056, 75061, 93143, 93144, 75062, 75059, 75065, 75058, 75069\n",
      "55496, 55487, 55485, 55500, 55493, 55499, 55490, 55494, 55489, 55502, 55495, 55491, 55486, 55492, 55501, 55497, 55498, 55488, 55503, 55484\n",
      "29520\n",
      "92056, 92050, 92049, 92046, 92055, 92051, 92053, 92048, 92047, 92057, 92054, 92052\n",
      "94012\n",
      "90732, 90733, 90731, 90734\n",
      "75914, 89584, 89581, 87305, 95573, 89582, 75915\n",
      "95856, 87871, 87886, 94707, 87887, 87884, 87885, 90719, 90004, 87870\n",
      "30189\n",
      "41512, 41513\n",
      "94415\n",
      "32523\n",
      "29446\n",
      "73754, 57294, 73755\n",
      "29433\n",
      "72194, 72192\n",
      "90490\n",
      "50539\n",
      "30932\n",
      "30017\n",
      "90419, 91736, 90420, 90418, 89361, 90422, 90423, 90421, 90424, 90417\n",
      "94828, 94829\n",
      "73356, 73355, 73357, 73354, 73353, 73358\n",
      "54210, 54211\n",
      "29397\n",
      "77260\n",
      "80152\n",
      "57394\n",
      "96392\n",
      "79822, 79821, 79820\n",
      "30236\n",
      "59280\n",
      "78868, 78870\n",
      "90364, 90362, 90363, 90361\n",
      "87639, 87356, 87637, 80022, 87355, 87638, 87357, 91734\n",
      "90116, 90115\n",
      "29584\n",
      "92655\n",
      "89125, 89124\n",
      "48776\n",
      "79076\n",
      "30887\n",
      "79001, 78961\n",
      "93281, 93284, 93282, 93286, 85878, 93291, 93289, 93288, 93290, 93283, 93292, 93287\n",
      "32569\n",
      "52310, 80622, 52311\n",
      "29140\n",
      "48554, 48553, 78952, 78954\n",
      "31335\n",
      "80352, 93090\n",
      "47338\n",
      "81257, 81258, 81259\n",
      "30389\n",
      "48377, 48378\n",
      "47095\n",
      "30509\n",
      "29056\n",
      "29312\n",
      "87302, 95577, 95578, 87301\n",
      "29465\n",
      "30789\n",
      "78523, 78522, 78521, 78510, 78520, 78518\n",
      "93991, 92985, 92987, 92984, 92986\n",
      "49637\n",
      "59583\n",
      "40929\n",
      "92337, 92339, 92338, 92336\n",
      "32426\n",
      "89070, 90725, 88993, 90724, 88994, 81200, 81202, 91198, 91199, 94393, 89071, 81203, 95962, 94394, 81204, 91197, 81201\n",
      "57366, 57367, 57368\n",
      "93150, 74975, 74969, 74973, 74972, 93152, 74977, 93149, 74971, 74979, 74970\n",
      "78986, 78981, 78983, 78984, 72669, 78985, 78982, 72668\n",
      "49610, 49609\n",
      "89120, 89121, 89118, 89122, 89115, 89119\n",
      "74974, 74976, 78987, 78988, 75438\n",
      "74978\n",
      "26289\n",
      "30889\n",
      "75883, 75886, 75887, 75885, 75884, 75890\n",
      "30797\n",
      "29915\n",
      "30198\n",
      "49925, 49926\n",
      "29341\n",
      "29598\n",
      "26394\n",
      "96159, 96158\n",
      "29697\n",
      "40489\n",
      "32468\n",
      "41942, 41943, 28939, 40363\n",
      "40516\n",
      "89291, 89293, 89296, 89294, 89295, 89292\n",
      "29100\n",
      "30415\n",
      "49895\n",
      "92506, 92507, 86597, 86595\n",
      "75053, 75054\n",
      "91281\n",
      "39275\n",
      "93316, 93313, 76791, 93314, 93315\n",
      "87155, 87154, 87153, 87152\n",
      "30204\n",
      "30162\n",
      "34524\n",
      "30788\n",
      "80239, 80240\n",
      "30907\n",
      "59741, 53963, 59744, 59745\n",
      "90491\n",
      "30039\n",
      "78220, 71279, 78221\n",
      "23624\n",
      "94534, 86208\n",
      "55250\n",
      "22854\n",
      "72671, 72674, 72672\n",
      "30205\n",
      "29313\n",
      "29918\n",
      "30206\n",
      "59755, 72233, 59754\n",
      "52171\n",
      "88265\n",
      "30881\n",
      "88172\n",
      "95108\n",
      "29439\n",
      "29382\n",
      "94969, 93121\n",
      "86748, 86751, 86749, 86750\n",
      "86013, 81024\n",
      "92445\n",
      "32824\n",
      "91690, 91692\n",
      "30195\n",
      "30933\n",
      "93319, 93321, 93320, 93322, 93323, 93324\n",
      "34812\n",
      "77566, 77563, 77564, 77565, 77558, 77567\n",
      "30420\n",
      "90911\n",
      "80166\n",
      "29101\n",
      "30007\n",
      "30434\n",
      "29454\n",
      "50795\n",
      "24588\n",
      "95562, 95561\n",
      "77987, 77988\n",
      "25033\n",
      "89073, 89076, 89075\n",
      "93326\n",
      "25103\n",
      "32555\n",
      "29376\n",
      "29390\n",
      "34523\n",
      "29914\n",
      "56222\n",
      "34944\n",
      "29715\n",
      "76609, 76610, 76611\n",
      "29788\n",
      "29378\n",
      "94955\n",
      "30833\n",
      "30831\n",
      "29161\n",
      "29180\n",
      "73752, 75530, 73747\n",
      "80665, 80666\n",
      "25031\n",
      "86233\n",
      "81032\n",
      "29124\n",
      "79106\n",
      "30888\n",
      "26317\n",
      "88168, 88167\n",
      "29374\n",
      "31020\n",
      "30207\n",
      "77571\n",
      "29578\n",
      "88173, 88174\n",
      "29132\n",
      "29103\n",
      "93165\n",
      "76559\n",
      "30030\n",
      "95566, 95565, 95564\n",
      "81094\n",
      "29538\n",
      "29590\n",
      "30897\n",
      "29169\n",
      "29611\n",
      "88170\n",
      "30910\n",
      "95567, 95571, 95572, 95570, 95568, 95569\n",
      "29156\n",
      "93166\n",
      "29392\n",
      "80771\n",
      "29733\n",
      "30934\n",
      "30916\n",
      "91574\n",
      "31043\n",
      "30223\n",
      "23635\n",
      "93339\n",
      "93026, 93675\n",
      "92780, 96010\n",
      "92440\n",
      "92443, 92444, 92247\n",
      "91502, 91498, 92565, 91500\n",
      "95886, 95913, 95912, 90694\n",
      "92549, 95405, 92547, 92548, 95404\n",
      "96042, 94729, 94732, 96040, 88532\n",
      "94716, 94738\n",
      "88393, 96372, 88193, 96268\n",
      "90796\n",
      "96434, 96437, 96436, 96435\n",
      "81234\n",
      "88942\n",
      "96070, 91492, 96071, 96110, 80546\n",
      "80517, 93647\n",
      "79161\n",
      "79118\n",
      "78599\n",
      "88618, 88788, 88790, 88787, 88789\n",
      "88796, 88795, 88797, 88798, 88617\n",
      "94750\n",
      "74739, 74265\n",
      "57131, 57129, 57130, 57128\n",
      "57124\n",
      "57123\n",
      "78486, 78485, 78487\n",
      "87952\n",
      "78535, 78534\n",
      "42354, 42353, 42352\n",
      "75138, 74913, 75139, 75137, 75140, 74910, 75136, 75141\n",
      "55397, 55398, 90261\n",
      "91490\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv('../static/data/info.csv')\n",
    "for i in df.values.tolist():\n",
    "    i[2][1:-1]"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2023-12-03T08:41:18.604674Z",
     "start_time": "2023-12-03T08:41:18.595376600Z"
    }
   },
   "id": "d642d14ee577f55d"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
